package com.china08.yxyapi.repository.db.lectureresult;

import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.transaction.annotation.Transactional;

import com.china08.yxyapi.entity.db.huodong.lecture.YxyHuodongResResultSchool;

public interface YxyHuodongResResultSchoolRepository extends JpaRepository<YxyHuodongResResultSchool, String> {

    Page<YxyHuodongResResultSchool> findByAreaIdDistrictAndSchoolNickContaining(String areaIdDistrict,
            String schoolName, Pageable pageable);

    Page<YxyHuodongResResultSchool> findByAreaIdDistrict(String areaIdDistrict, Pageable pageable);

    @Modifying
    @Transactional
    Integer deleteByAreaIdDistrict(String areaNameDistrict);

}
